"SQLSTATE[23000]: Integrity constraint violation" in Doctrine
Posted
by rags
on Stack Overflow
See other posts from Stack Overflow
or by rags
Published on 2010-05-28T13:20:00Z
Indexed on
2010/05/28
13:21 UTC
Read the original article
Hit count: 252
Hi,
i do get an Integrity constraint violation for Doctrine though i really can't see why.
Schema.yml
User:
columns:
id:
type: integer
primary: true
autoincrement: true
username:
type: varchar(64)
notnull: true
email:
type: varchar(128)
notnull: true
password:
type: varchar(128)
notnull: true
relations:
Websites:
class: Website
local: id
foreign: owner
type: many
foreignType: one
onDelete: CASCADE
Website:
columns:
id:
type: integer
primary: true
autoincrement: true
active:
type: bool
owner:
type: integer
notnull: true
plz:
type: integer
notnull: true
longitude:
type: double(10,6)
notnull: true
latitude:
type: double(10,6)
notnull: true
relations:
Owner:
type: one
foreignType: many
class: User
local: owner
foreign: id
And here's my data Fixtures (data.yml)
Model_User:
User_1:
username: as
email: as****.com
password: *****
Model_Website:
Website_1:
active: true
plz: 34222
latitude: 13.12
longitude: 3.56
Owner: User_1
© Stack Overflow or respective owner